a. Prepare a simple three year budget, from the following information. 2,000 units are sold in year 1, sales increase 20% in Year 2, and then increase an additional 10% in year 3.Production costs are $2 per unit (variable), plus one-off fixed c
AnFTutor (Not rated)
(Not rated)
| a. Prepare a simple three year budget, from the following information. 2,000 units are sold in year 1, sales increase 20% in Year 2, and then increase an additional 10% in year 3.Production costs are $2 per unit (variable), | ||||||||||||||||
| plus one-off fixed costs of $2K per annum. Sales commission costs are 10% of sales. Units are sold for $420 per unit. Overheads are $4K per annum. Costs will rise 5% in year 2 and again in year 3. | ||||||||||||||||
| Prepare your answer using MS Excel, and also write a report in MS Word illustrating the key points of the budget. | ||||||||||||||||
| Prepare a simple three-year budget from the following information: 2,000 units are sold in year 1, sales increase 20% in year 2, and then increase an additional 10% in year 3. Production costs are variable at $200 per unit, plus one-time fixed costs of $2,000 per annum. Sales commission costs are 10% of sales. Units are sold for $420 per unit. Overheads are $4,000 per annum. Costs will rise 5% in year 2 and again in year 3. | ||||||||||||||||
12 years ago
a. Prepare a simple three year budget, from the following information. 2,000 units are sold in year 1, sales increase 20% in Year 2, and then increase an additional 10% in year 3.Production costs are $2 per unit (variable), plus one-off fixed c
NOT RATED
Purchase the answer to view it
ocbuac-122712-napa1_-_part_2.xlsx
